Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	5693
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	533.8 KiB
Average record size in memory	96.0 B

Variable types

Numeric	12

Alerts

`gross_revenue` is highly correlated with `qty_invoice_no` and 3 other fields	High correlation
`recency_days` is highly correlated with `qty_invoice_no`	High correlation
`qty_invoice_no` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`qty_items` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`qty_products` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`frequency` is highly correlated with `qty_invoice_no` and 1 other fields	High correlation
`qty_returns` is highly correlated with `qty_invoice_no`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qty_products` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qty_invoice_no` and 1 other fields	High correlation
`qty_invoice_no` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qty_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`qty_products` is highly correlated with `qty_invoice_no`	High correlation
`gross_revenue` is highly correlated with `qty_invoice_no` and 3 other fields	High correlation
`qty_invoice_no` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qty_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qty_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`frequency` is highly correlated with `qty_invoice_no`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qty_products`	High correlation
`df_index` is highly correlated with `customer_id` and 1 other fields	High correlation
`customer_id` is highly correlated with `df_index` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qty_invoice_no` and 3 other fields	High correlation
`recency_days` is highly correlated with `df_index` and 1 other fields	High correlation
`qty_invoice_no` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qty_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qty_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `qty_returns` and 1 other fields	High correlation
`qty_returns` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 2 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `avg_basket_size`	High correlation
`gross_revenue` is highly skewed (γ1 = 23.14756188)	Skewed
`qty_items` is highly skewed (γ1 = 25.0992138)	Skewed
`avg_ticket` is highly skewed (γ1 = 24.95802561)	Skewed
`qty_returns` is highly skewed (γ1 = 30.34012229)	Skewed
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`qty_returns` has 4191 (73.6%) zeros	Zeros

Reproduction

Analysis started	2022-04-12 00:51:56.255249
Analysis finished	2022-04-12 00:52:10.985659
Duration	14.73 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	5693
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2894.801159

Minimum	0
Maximum	5783
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	289.6
Q1	1454
median	2897
Q3	4339
95-th percentile	5492.4
Maximum	5783
Range	5783
Interquartile range (IQR)	2885

Descriptive statistics

Standard deviation	1668.359199
Coefficient of variation (CV)	0.5763294635
Kurtosis	-1.196239465
Mean	2894.801159
Median Absolute Deviation (MAD)	1443
Skewness	-0.003575526764
Sum	16480103
Variance	2783422.417
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3888	1	< 0.1%
3864	1	< 0.1%
3863	1	< 0.1%
3862	1	< 0.1%
3861	1	< 0.1%
3860	1	< 0.1%
3859	1	< 0.1%
3858	1	< 0.1%
3857	1	< 0.1%
Other values (5683)	5683	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5783	1	< 0.1%
5782	1	< 0.1%
5781	1	< 0.1%
5780	1	< 0.1%
5779	1	< 0.1%
5778	1	< 0.1%
5777	1	< 0.1%
5776	1	< 0.1%
5775	1	< 0.1%
5774	1	< 0.1%

customer_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	5693
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16601.61022

Minimum	12347
Maximum	22709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	12347
5-th percentile	12700.6
Q1	14289
median	16229
Q3	18211
95-th percentile	21732.8
Maximum	22709
Range	10362
Interquartile range (IQR)	3922

Descriptive statistics

Standard deviation	2808.098224
Coefficient of variation (CV)	0.1691461362
Kurtosis	-0.8214808648
Mean	16601.61022
Median Absolute Deviation (MAD)	1962
Skewness	0.4410508271
Sum	94512967
Variance	7885415.636
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
21111	1	< 0.1%
16498	1	< 0.1%
13745	1	< 0.1%
15584	1	< 0.1%
21089	1	< 0.1%
21088	1	< 0.1%
21087	1	< 0.1%
21086	1	< 0.1%
15578	1	< 0.1%
Other values (5683)	5683	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%
12357	1	< 0.1%

Value	Count	Frequency (%)
22709	1	< 0.1%
22708	1	< 0.1%
22707	1	< 0.1%
22706	1	< 0.1%
22705	1	< 0.1%
22704	1	< 0.1%
22700	1	< 0.1%
22699	1	< 0.1%
22696	1	< 0.1%
22695	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	5447
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1754.357676

Minimum	0.42
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.42
5-th percentile	13.128
Q1	236.09
median	612.78
Q3	1569.11
95-th percentile	5260.23
Maximum	279138.02
Range	279137.6
Interquartile range (IQR)	1333.02

Descriptive statistics

Standard deviation	7500.337959
Coefficient of variation (CV)	4.275261574
Kurtosis	704.3157538
Mean	1754.357676
Median Absolute Deviation (MAD)	478.74
Skewness	23.14756188
Sum	9987558.25
Variance	56255069.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.95	9	0.2%
1.25	8	0.1%
2.95	8	0.1%
4.95	8	0.1%
1.65	7	0.1%
12.75	7	0.1%
3.75	7	0.1%
5.95	6	0.1%
4.25	6	0.1%
7.5	6	0.1%
Other values (5437)	5621	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%
1.69	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	304
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.8796768

Minimum	0
Maximum	373
Zeros	37
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	23
median	71
Q3	200
95-th percentile	338
Maximum	373
Range	373
Interquartile range (IQR)	177

Descriptive statistics

Standard deviation	111.6285712
Coefficient of variation (CV)	0.9550725521
Kurtosis	-0.641033991
Mean	116.8796768
Median Absolute Deviation (MAD)	61
Skewness	0.8151071897
Sum	665396
Variance	12460.93791
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	110	1.9%
4	105	1.8%
3	98	1.7%
2	92	1.6%
10	86	1.5%
8	82	1.4%
17	79	1.4%
9	79	1.4%
7	78	1.4%
15	66	1.2%
Other values (294)	4818	84.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	37	0.6%
1	110	1.9%
2	92	1.6%
3	98	1.7%
4	105	1.8%
5	52	0.9%
7	78	1.4%
8	82	1.4%
9	79	1.4%
10	86	1.5%

Value	Count	Frequency (%)
373	23	0.4%
372	23	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	15	0.3%
365	19	0.3%
364	11	0.2%
362	7	0.1%

qty_invoice_no
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	56
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.471807483

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	11
Maximum	206
Range	205
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	6.814409585
Coefficient of variation (CV)	1.962784405
Kurtosis	301.9942725
Mean	3.471807483
Median Absolute Deviation (MAD)	0
Skewness	13.19072233
Sum	19765
Variance	46.43617799
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2870	50.4%
2	825	14.5%
3	502	8.8%
4	394	6.9%
5	237	4.2%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	69	1.2%
10	55	1.0%
Other values (46)	332	5.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2870	50.4%
2	825	14.5%
3	502	8.8%
4	394	6.9%
5	237	4.2%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	69	1.2%
10	55	1.0%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%
57	1	< 0.1%

qty_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1839
Distinct (%)	32.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	951.7071843

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	106
median	317
Q3	804
95-th percentile	2925.2
Maximum	196844
Range	196843
Interquartile range (IQR)	698

Descriptive statistics

Standard deviation	4189.908875
Coefficient of variation (CV)	4.402518909
Kurtosis	942.5110255
Mean	951.7071843
Median Absolute Deviation (MAD)	253
Skewness	25.0992138
Sum	5418069
Variance	17555336.38
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	2.0%
2	73	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	25	0.4%
88	22	0.4%
72	21	0.4%
7	20	0.4%
Other values (1829)	5254	92.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	114	2.0%
2	73	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
7	20	0.4%
8	18	0.3%
9	7	0.1%
10	17	0.3%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

qty_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	529
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.64131389

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	14
median	41
Q3	106
95-th percentile	332.4
Maximum	7838
Range	7837
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	210.6087384
Coefficient of variation (CV)	2.273378146
Kurtosis	510.1702143
Mean	92.64131389
Median Absolute Deviation (MAD)	33
Skewness	17.75158488
Sum	527407
Variance	44356.04068
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	255	4.5%
2	149	2.6%
3	107	1.9%
10	101	1.8%
6	99	1.7%
9	92	1.6%
5	91	1.6%
4	87	1.5%
11	83	1.5%
7	83	1.5%
Other values (519)	4546	79.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	255	4.5%
2	149	2.6%
3	107	1.9%
4	87	1.5%
5	91	1.6%
6	99	1.7%
7	83	1.5%
8	81	1.4%
9	92	1.6%
10	101	1.8%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	5500
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.86799676

Minimum	0.42
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.42
5-th percentile	3.459660952
Q1	7.95
median	15.85181818
Q3	21.97516949
95-th percentile	75.86392342
Maximum	4453.43
Range	4453.01
Interquartile range (IQR)	14.02516949

Descriptive statistics

Standard deviation	115.5612063
Coefficient of variation (CV)	4.003090594
Kurtosis	791.1895729
Mean	28.86799676
Median Absolute Deviation (MAD)	7.493397129
Skewness	24.95802561
Sum	164345.5056
Variance	13354.3924
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.75	11	0.2%
4.95	10	0.2%
2.95	9	0.2%
1.25	9	0.2%
7.95	8	0.1%
1.65	7	0.1%
8.25	7	0.1%
12.75	7	0.1%
3.35	6	0.1%
15	6	0.1%
Other values (5490)	5613	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.42	3	0.1%
0.535	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.8371428571	1	< 0.1%
0.84	2	< 0.1%
0.85	3	0.1%
1.002222222	1	< 0.1%
1.02	1	< 0.1%
1.03875	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
3861	1	< 0.1%
3202.92	1	< 0.1%
3096	1	< 0.1%
1687.2	1	< 0.1%
1377.077778	1	< 0.1%
1001.2	1	< 0.1%
952.9875	1	< 0.1%
931.5	1	< 0.1%
872.13	1	< 0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1226
Distinct (%)	21.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5467863142

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.01104159896
Q1	0.02492211838
median	1
Q3	1
95-th percentile	1
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.9750778816

Descriptive statistics

Standard deviation	0.5493600313
Coefficient of variation (CV)	1.004706989
Kurtosis	140.0664152
Mean	0.5467863142
Median Absolute Deviation (MAD)	0
Skewness	4.871258314
Sum	3112.854487
Variance	0.301796444
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2878	50.6%
2	47	0.8%
0.0625	18	0.3%
0.02777777778	17	0.3%
0.02380952381	16	0.3%
0.08333333333	15	0.3%
0.09090909091	15	0.3%
0.03448275862	14	0.2%
0.02941176471	14	0.2%
0.03571428571	13	0.2%
Other values (1216)	2646	46.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	< 0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	< 0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	< 0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
4	1	< 0.1%
3	4	0.1%
2	47	0.8%
1.142857143	1	< 0.1%
1	2878	50.6%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%

qty_returns
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	213
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.23256631

Minimum	0
Maximum	9014
Zeros	4191
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	38
Maximum	9014
Range	9014
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	204.9662983
Coefficient of variation (CV)	11.24176898
Kurtosis	1138.689658
Mean	18.23256631
Median Absolute Deviation (MAD)	0
Skewness	30.34012229
Sum	103798
Variance	42011.18343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4191	73.6%
1	169	3.0%
2	150	2.6%
3	105	1.8%
4	89	1.6%
6	78	1.4%
5	61	1.1%
12	52	0.9%
7	44	0.8%
8	43	0.8%
Other values (203)	711	12.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4191	73.6%
1	169	3.0%
2	150	2.6%
3	105	1.8%
4	89	1.6%
5	61	1.1%
6	78	1.4%
7	44	0.8%
8	43	0.8%
9	41	0.7%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2367
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	248.1620234

Minimum	1
Maximum	14149
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	75
median	151.6666667
Q3	290
95-th percentile	732.55
Maximum	14149
Range	14148
Interquartile range (IQR)	215

Descriptive statistics

Standard deviation	439.5046618
Coefficient of variation (CV)	1.771039162
Kurtosis	378.6486311
Mean	248.1620234
Median Absolute Deviation (MAD)	96.66666667
Skewness	14.57309198
Sum	1412786.399
Variance	193164.3477
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	115	2.0%
2	72	1.3%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	26	0.5%
100	22	0.4%
72	22	0.4%
88	21	0.4%
Other values (2357)	5251	92.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	115	2.0%
2	72	1.3%
3	51	0.9%
3.333333333	1	< 0.1%
4	49	0.9%
5	35	0.6%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6	29	0.5%
6.142857143	1	< 0.1%

Value	Count	Frequency (%)
14149	1	< 0.1%
13956	1	< 0.1%
7824	1	< 0.1%
6009.333333	1	< 0.1%
5963	1	< 0.1%
5197	1	< 0.1%
4300	1	< 0.1%
4282	1	< 0.1%
4280	1	< 0.1%
4136	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1171
Distinct (%)	20.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.26861967

Minimum	0.2
Maximum	1109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.6 KiB

Quantile statistics

Minimum	0.2
5-th percentile	1
Q1	7.25
median	15
Q3	31
95-th percentile	173
Maximum	1109
Range	1108.8
Interquartile range (IQR)	23.75

Descriptive statistics

Standard deviation	76.8933091
Coefficient of variation (CV)	2.063218595
Kurtosis	32.87862237
Mean	37.26861967
Median Absolute Deviation (MAD)	9.941176471
Skewness	5.072820295
Sum	212170.2518
Variance	5912.580985
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	277	4.9%
2	161	2.8%
3	115	2.0%
10	105	1.8%
9	105	1.8%
8	103	1.8%
7	101	1.8%
6	101	1.8%
5	101	1.8%
13	97	1.7%
Other values (1161)	4427	77.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.1%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.2%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
1109	1	< 0.1%
748	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%
703	1	< 0.1%
686	1	< 0.1%
675	1	< 0.1%
673	1	< 0.1%
660	1	< 0.1%
649	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qty_invoice_no	qty_items	qty_products	avg_ticket	frequency	qty_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	18.152222	17.000000	40.0	50.970588	0.617647
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	18.904035	0.028302	35.0	154.444444	11.666667
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	28.902500	0.040323	50.0	335.200000	7.600000
3	3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	0.017921	0.0	87.800000	4.800000
4	4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	0.073171	22.0	26.666667	0.333333
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	45.326471	0.040115	29.0	150.142857	4.357143
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	0.057221	399.0	172.428571	7.047619
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	88.719836	0.033520	41.0	171.416667	3.833333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	0.243316	474.0	419.714286	6.230769
9	9	16098	2005.63	87.0	7.0	613.0	67.0	29.934776	0.024390	0.0	87.571429	4.857143

Last rows

	df_index	customer_id	gross_revenue	recency_days	qty_invoice_no	qty_items	qty_products	avg_ticket	frequency	avg_basket_size	avg_unique_basket_size
5683	5774	22700	4839.42	1.0	1.0	1074.0	62.0	78.055161	1.0	1074.0	55.0
5684	5775	13298	360.00	1.0	1.0	96.0	2.0	180.000000	1.0	96.0	2.0
5685	5776	14569	227.39	1.0	1.0	79.0	12.0	18.949167	1.0	79.0	10.0
5686	5777	22704	17.90	1.0	1.0	14.0	7.0	2.557143	1.0	14.0	7.0
5687	5778	22705	3.35	1.0	1.0	2.0	2.0	1.675000	1.0	2.0	2.0
5688	5779	22706	5699.00	1.0	1.0	1747.0	634.0	8.988959	1.0	1747.0	634.0
5689	5780	22707	6756.06	0.0	1.0	2010.0	730.0	9.254877	1.0	2010.0	730.0
5690	5781	22708	3217.20	0.0	1.0	654.0	59.0	54.528814	1.0	654.0	56.0
5691	5782	22709	3950.72	0.0	1.0	731.0	217.0	18.206083	1.0	731.0	217.0
5692	5783	12713	794.55	0.0	1.0	505.0	37.0	21.474324	1.0	505.0	37.0

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows